home *** CD-ROM | disk | FTP | other *** search
- VERSION 2.00
- Begin Form Form1
- BackColor = &H00C0C0C0&
- Caption = "Search a List Box"
- ClientHeight = 3780
- ClientLeft = 1095
- ClientTop = 1485
- ClientWidth = 3750
- Height = 4185
- Left = 1035
- LinkMode = 1 'Source
- LinkTopic = "Form1"
- MaxButton = 0 'False
- ScaleHeight = 3780
- ScaleWidth = 3750
- Top = 1140
- Width = 3870
- Begin CommandButton btnExit
- Cancel = -1 'True
- Caption = "E&xit"
- Height = 495
- Left = 2160
- TabIndex = 4
- Top = 3120
- Width = 1215
- End
- Begin CommandButton btnOK
- Caption = "&Ok"
- Default = -1 'True
- Height = 495
- Left = 360
- TabIndex = 3
- Top = 3120
- Width = 1215
- End
- Begin ListBox List1
- Height = 1980
- Left = 120
- Sorted = -1 'True
- TabIndex = 2
- Tag = "List1"
- Top = 960
- Width = 3495
- End
- Begin TextBox Text1
- Height = 375
- Left = 120
- TabIndex = 1
- Tag = "Text1"
- Top = 480
- Width = 3495
- End
- Begin Label Label1
- Alignment = 2 'Center
- Caption = "&Search for cities on my phone bill:"
- Height = 255
- Left = 120
- TabIndex = 0
- Top = 120
- Width = 3495
- End
- Sub btnExit_Click ()
- End
- End Sub
- Sub btnOK_Click ()
- MsgBox "You selected " + List1.Text
- End Sub
- Sub Form_Load ()
- List1.AddItem "a"
- List1.AddItem "ab"
- List1.AddItem "abc"
- List1.AddItem "abcd"
- List1.AddItem "abcde"
- List1.AddItem "abcdef"
- List1.AddItem "abcdefg"
- List1.AddItem "abcdefg"
- List1.AddItem "abcdefgh"
- List1.AddItem "abcdefghi"
- List1.AddItem "abcdefghij"
- List1.AddItem "abcdefghijk"
- List1.AddItem "abcdefghijk"
- List1.AddItem "abcdefghijkl"
- List1.AddItem "Sunnyvale"
- List1.AddItem "San Jose"
- List1.AddItem "Santa Cruz"
- List1.AddItem "Scotts Valley"
- List1.AddItem "Chicago"
- List1.AddItem "Lowell"
- List1.AddItem "Roswell"
- List1.AddItem "Cambridge"
- List1.AddItem "Muskegon"
- List1.AddItem "Agoura"
- List1.AddItem "Englewood"
- List1.AddItem "Bellevue"
- List1.AddItem "Anaheim"
- List1.AddItem "Newkirk"
- List1.AddItem "Edmond"
- List1.AddItem "Oklahoma City"
- List1.AddItem "Crescent"
- List1.AddItem "Guthrie"
- List1.AddItem "Perry"
- List1.AddItem "Midwest City"
- List1.AddItem "Kremlin"
- List1.AddItem "Wakita"
- List1.AddItem "Medford"
- List1.AddItem "Enid"
- List1.AddItem "Waukomis"
- List1.AddItem "Kildare"
- List1.AddItem "Yukon"
- List1.AddItem "Moore"
- List1.AddItem "Wichita"
- List1.AddItem "Topeka"
- List1.AddItem "Kansas City"
- List1.AddItem "Coffeyville"
- List1.AddItem "Hutchison"
- List1.AddItem "Arkansas City"
- List1.AddItem "Winfield"
- List1.AddItem "Lions"
- List1.AddItem "Tonkawa"
- List1.AddItem "Blackwell"
- List1.AddItem "Ponca City"
- List1.AddItem "Kaw City"
- List1.AddItem "Dallas"
- List1.AddItem "Fort Worth"
- List1.AddItem "Houston"
- List1.AddItem "Miami"
- List1.AddItem "Fort Lauderdale"
- List1.AddItem "Denver"
- List1.AddItem "Colorado Springs"
- List1.AddItem "Washington D.C."
- List1.AddItem "Bismark"
- List1.AddItem "Lincoln"
- List1.AddItem "Las Vegas"
- List1.AddItem "Eureka Springs"
- List1.AddItem "Branson"
- List1.AddItem "Boise"
- List1.AddItem "Redmond"
- List1.AddItem "Reno"
- List1.AddItem "Jacksonville"
- List1.AddItem "New Orleans"
- List1.AddItem "Atlanta"
- List1.AddItem "New York"
- List1.AddItem "Sacremento"
- List1.AddItem "Boston"
- List1.AddItem "Detroit"
- List1.AddItem "Pitsburg"
- List1.AddItem "Albany"
- List1.AddItem "Nashville"
- List1.AddItem "Amarillo"
- List1.AddItem "Woodward"
- List1.AddItem "Tulsa"
- List1.AddItem "Bartlesville"
- List1.AddItem "Columbus"
- List1.AddItem "Yukon"
- List1.AddItem "Ardmore"
- List1.AddItem "Altus"
- List1.AddItem "Sunnyvale"
- List1.AddItem "San Jose"
- List1.AddItem "Santa Cruz"
- List1.AddItem "Scotts Valley"
- List1.AddItem "Chicago"
- List1.AddItem "Lowell"
- List1.AddItem "Roswell"
- List1.AddItem "Cambridge"
- List1.AddItem "Muskegon"
- List1.AddItem "Agoura"
- List1.AddItem "Englewood"
- List1.AddItem "Bellevue"
- List1.AddItem "Anaheim"
- List1.AddItem "Newkirk"
- List1.AddItem "Edmond"
- List1.AddItem "Oklahoma City"
- List1.AddItem "Crescent"
- List1.AddItem "Guthrie"
- List1.AddItem "Perry"
- List1.AddItem "Midwest City"
- List1.AddItem "Kremlin"
- List1.AddItem "Wakita"
- List1.AddItem "Medford"
- List1.AddItem "Enid"
- List1.AddItem "Waukomis"
- List1.AddItem "Kildare"
- List1.AddItem "Yukon"
- List1.AddItem "Moore"
- List1.AddItem "Wichita"
- List1.AddItem "Topeka"
- List1.AddItem "Kansas City"
- List1.AddItem "Coffeyville"
- List1.AddItem "Hutchison"
- List1.AddItem "Arkansas City"
- List1.AddItem "Winfield"
- List1.AddItem "Lions"
- List1.AddItem "Tonkawa"
- List1.AddItem "Blackwell"
- List1.AddItem "Ponca City"
- List1.AddItem "Kaw City"
- List1.AddItem "Dallas"
- List1.AddItem "Fort Worth"
- List1.AddItem "Houston"
- List1.AddItem "Miami"
- List1.AddItem "Fort Lauderdale"
- List1.AddItem "Denver"
- List1.AddItem "Colorado Springs"
- List1.AddItem "Washington D.C."
- List1.AddItem "Bismark"
- List1.AddItem "Lincoln"
- List1.AddItem "Las Vegas"
- List1.AddItem "Eureka Springs"
- List1.AddItem "Branson"
- List1.AddItem "Boise"
- List1.AddItem "Redmond"
- List1.AddItem "Reno"
- List1.AddItem "Jacksonville"
- List1.AddItem "New Orleans"
- List1.AddItem "Atlanta"
- List1.AddItem "New York"
- List1.AddItem "Sacremento"
- List1.AddItem "Boston"
- List1.AddItem "Detroit"
- List1.AddItem "Pitsburg"
- List1.AddItem "Albany"
- List1.AddItem "Nashville"
- List1.AddItem "Amarillo"
- List1.AddItem "Woodward"
- List1.AddItem "Tulsa"
- List1.AddItem "Bartlesville"
- List1.AddItem "Columbus"
- List1.AddItem "Yukon"
- List1.AddItem "Ardmore"
- List1.AddItem "Altus"
- List1.AddItem "Sunnyvale"
- List1.AddItem "San Jose"
- List1.AddItem "Santa Cruz"
- List1.AddItem "Scotts Valley"
- List1.AddItem "Chicago"
- List1.AddItem "Lowell"
- List1.AddItem "Roswell"
- List1.AddItem "Cambridge"
- List1.AddItem "Muskegon"
- List1.AddItem "Agoura"
- List1.AddItem "Englewood"
- List1.AddItem "Bellevue"
- List1.AddItem "Anaheim"
- List1.AddItem "Newkirk"
- List1.AddItem "Edmond"
- List1.AddItem "Oklahoma City"
- List1.AddItem "Crescent"
- List1.AddItem "Guthrie"
- List1.AddItem "Perry"
- List1.AddItem "Midwest City"
- List1.AddItem "Kremlin"
- List1.AddItem "Wakita"
- List1.AddItem "Medford"
- List1.AddItem "Enid"
- List1.AddItem "Waukomis"
- List1.AddItem "Kildare"
- List1.AddItem "Yukon"
- List1.AddItem "Moore"
- List1.AddItem "Wichita"
- List1.AddItem "Topeka"
- List1.AddItem "Kansas City"
- List1.AddItem "Coffeyville"
- List1.AddItem "Hutchison"
- List1.AddItem "Arkansas City"
- List1.AddItem "Winfield"
- List1.AddItem "Lions"
- List1.AddItem "Tonkawa"
- List1.AddItem "Blackwell"
- List1.AddItem "Ponca City"
- List1.AddItem "Kaw City"
- List1.AddItem "Dallas"
- List1.AddItem "Fort Worth"
- List1.AddItem "Houston"
- List1.AddItem "Miami"
- List1.AddItem "Fort Lauderdale"
- List1.AddItem "Denver"
- List1.AddItem "Colorado Springs"
- List1.AddItem "Washington D.C."
- List1.AddItem "Bismark"
- List1.AddItem "Lincoln"
- List1.AddItem "Las Vegas"
- List1.AddItem "Eureka Springs"
- List1.AddItem "Branson"
- List1.AddItem "Boise"
- List1.AddItem "Redmond"
- List1.AddItem "Reno"
- List1.AddItem "Jacksonville"
- List1.AddItem "New Orleans"
- List1.AddItem "Atlanta"
- List1.AddItem "New York"
- List1.AddItem "Sacremento"
- List1.AddItem "Boston"
- List1.AddItem "Detroit"
- List1.AddItem "Pitsburg"
- List1.AddItem "Albany"
- List1.AddItem "Nashville"
- List1.AddItem "Amarillo"
- List1.AddItem "Woodward"
- List1.AddItem "Tulsa"
- List1.AddItem "Bartlesville"
- List1.AddItem "Columbus"
- List1.AddItem "Yukon"
- List1.AddItem "Ardmore"
- List1.AddItem "Altus"
- List1.AddItem "Sunnyvale"
- List1.AddItem "San Jose"
- List1.AddItem "Santa Cruz"
- List1.AddItem "Scotts Valley"
- List1.AddItem "Chicago"
- List1.AddItem "Lowell"
- List1.AddItem "Roswell"
- List1.AddItem "Cambridge"
- List1.AddItem "Muskegon"
- List1.AddItem "Agoura"
- List1.AddItem "Englewood"
- List1.AddItem "Bellevue"
- List1.AddItem "Anaheim"
- List1.AddItem "Newkirk"
- List1.AddItem "Edmond"
- List1.AddItem "Oklahoma City"
- List1.AddItem "Crescent"
- List1.AddItem "Guthrie"
- List1.AddItem "Perry"
- List1.AddItem "Midwest City"
- List1.AddItem "Kremlin"
- List1.AddItem "Wakita"
- List1.AddItem "Medford"
- List1.AddItem "Enid"
- List1.AddItem "Waukomis"
- List1.AddItem "Kildare"
- List1.AddItem "Yukon"
- List1.AddItem "Moore"
- List1.AddItem "Wichita"
- List1.AddItem "Topeka"
- List1.AddItem "Kansas City"
- List1.AddItem "Coffeyville"
- List1.AddItem "Hutchison"
- List1.AddItem "Arkansas City"
- List1.AddItem "Winfield"
- List1.AddItem "Lions"
- List1.AddItem "Tonkawa"
- List1.AddItem "Blackwell"
- List1.AddItem "Ponca City"
- List1.AddItem "Kaw City"
- List1.AddItem "Dallas"
- List1.AddItem "Fort Worth"
- List1.AddItem "Houston"
- List1.AddItem "Miami"
- List1.AddItem "Fort Lauderdale"
- List1.AddItem "Denver"
- List1.AddItem "Colorado Springs"
- List1.AddItem "Washington D.C."
- List1.AddItem "Bismark"
- List1.AddItem "Lincoln"
- List1.AddItem "Las Vegas"
- List1.AddItem "Eureka Springs"
- List1.AddItem "Branson"
- List1.AddItem "Boise"
- List1.AddItem "Redmond"
- List1.AddItem "Reno"
- List1.AddItem "Jacksonville"
- List1.AddItem "New Orleans"
- List1.AddItem "Atlanta"
- List1.AddItem "New York"
- List1.AddItem "Sacremento"
- List1.AddItem "Boston"
- List1.AddItem "Detroit"
- List1.AddItem "Pitsburg"
- List1.AddItem "Albany"
- List1.AddItem "Nashville"
- List1.AddItem "Amarillo"
- List1.AddItem "Woodward"
- List1.AddItem "Tulsa"
- List1.AddItem "Bartlesville"
- List1.AddItem "Columbus"
- List1.AddItem "Yukon"
- List1.AddItem "Ardmore"
- List1.AddItem "Altus"
- List1.AddItem "Sunnyvale"
- List1.AddItem "San Jose"
- List1.AddItem "Santa Cruz"
- List1.AddItem "Scotts Valley"
- List1.AddItem "Chicago"
- List1.AddItem "Lowell"
- List1.AddItem "Roswell"
- List1.AddItem "Cambridge"
- List1.AddItem "Muskegon"
- List1.AddItem "Agoura"
- List1.AddItem "Englewood"
- List1.AddItem "Bellevue"
- List1.AddItem "Anaheim"
- List1.AddItem "Newkirk"
- List1.AddItem "Edmond"
- List1.AddItem "Oklahoma City"
- List1.AddItem "Crescent"
- List1.AddItem "Guthrie"
- List1.AddItem "Perry"
- List1.AddItem "Midwest City"
- List1.AddItem "Kremlin"
- List1.AddItem "Wakita"
- List1.AddItem "Medford"
- List1.AddItem "Enid"
- List1.AddItem "Waukomis"
- List1.AddItem "Kildare"
- List1.AddItem "Yukon"
- List1.AddItem "Moore"
- List1.AddItem "Wichita"
- List1.AddItem "Topeka"
- List1.AddItem "Kansas City"
- List1.AddItem "Coffeyville"
- List1.AddItem "Hutchison"
- List1.AddItem "Arkansas City"
- List1.AddItem "Winfield"
- List1.AddItem "Lions"
- List1.AddItem "Tonkawa"
- List1.AddItem "Blackwell"
- List1.AddItem "Ponca City"
- List1.AddItem "Kaw City"
- List1.AddItem "Dallas"
- List1.AddItem "Fort Worth"
- List1.AddItem "Houston"
- List1.AddItem "Miami"
- List1.AddItem "Fort Lauderdale"
- List1.AddItem "Denver"
- List1.AddItem "Colorado Springs"
- List1.AddItem "Washington D.C."
- List1.AddItem "Bismark"
- List1.AddItem "Lincoln"
- List1.AddItem "Las Vegas"
- List1.AddItem "Eureka Springs"
- List1.AddItem "Branson"
- List1.AddItem "Boise"
- List1.AddItem "Redmond"
- List1.AddItem "Reno"
- List1.AddItem "Jacksonville"
- List1.AddItem "New Orleans"
- List1.AddItem "Atlanta"
- List1.AddItem "New York"
- List1.AddItem "Sacremento"
- List1.AddItem "Boston"
- List1.AddItem "Detroit"
- List1.AddItem "Pitsburg"
- List1.AddItem "Albany"
- List1.AddItem "Nashville"
- List1.AddItem "Amarillo"
- List1.AddItem "Woodward"
- List1.AddItem "Tulsa"
- List1.AddItem "Bartlesville"
- List1.AddItem "Columbus"
- List1.AddItem "Yukon"
- List1.AddItem "Ardmore"
- List1.AddItem "Altus"
- End Sub
- Sub List1_Click ()
- If Screen.ActiveControl.Tag = List1.Tag Then
- Text1.Text = List1.Text
- End If
- End Sub
- Sub List1_DblClick ()
- btnOK_Click
- End Sub
- Sub Text1_Change ()
- 'Only execute the subroutine if it was called from its own control item
- If Not Screen.ActiveControl.Tag = Text1.Tag Then
- Exit Sub
- End If
- Dim SearchFor As String
- Dim SearchLen As Integer
- Dim Lesser As Integer
- Dim CurrentNumber As Integer
- Dim CurrentItem As String
- Dim Greater As Integer
- SearchFor = UCase$(Text1.Text)
- If Len(SearchFor) > 0 And List1.ListCount > 0 Then
- Lesser = 0
- Greater = List1.ListCount - 1
- 'Perform a binary search for a match, quick!
- Do While Lesser + 1 <> Greater And Lesser <> Greater
- CurrentNumber = Lesser + Int((Greater - Lesser) / 2 + .5)
- CurrentItem = UCase$(Left$(List1.List(CurrentNumber), Len(SearchFor)))
- If CurrentItem = SearchFor Then
- Greater = CurrentNumber
- Else
- If CurrentNumber = Lesser Or CurrentNumber = Greater Then
- Exit Do
- Else
- If CurrentItem < SearchFor Then
- Lesser = CurrentNumber
- Else
- Greater = CurrentNumber
- End If
- End If
- End If
- Loop
- If UCase$(Left$(List1.List(Lesser), Len(SearchFor))) = SearchFor Then
- List1.ListIndex = Lesser
- Else
- If UCase$(Left$(List1.List(Greater), Len(SearchFor))) = SearchFor Then
- List1.ListIndex = Greater
- End If
- End If
- End If
- End Sub
-